home *** CD-ROM | disk | FTP | other *** search
- Read Me First: SQL-Sombrero/VBX 1.0.4 for DB-Library
-
- **** EVALUATION COPY *****
- *************************************************************
- This is an Evaluation Version with "Nag" Screens. Please
- call SFI at 819 778-5045 to order the production copy of the
- product.
- *************************************************************
-
- The diskette has an installation program which makes installation of the
- SQL-Sombrero product painless. To run the install program:
- - place diskette into drive
- - from the File menu of program manager chose Run
- - type the following a:\install (assuming your 3.5" drive is drive a:)
- - you will given the choice to perform a Full Install or a Custom Install
- - you will also be allow to change the directory to which the components of
- the SQL-Sombrero/VBX package will be installed. The default directory is
- C:\SQL\SQLVBXDB
- - if you select the Full Install then all the components of SQL-Sombrero/VBX
- will be installed in the directory chosen.
- - the Custom Install allow you to select components to install. It can be
- also used to install components that were not installed previously at a later
- date.
-
- The files are installed in the following directories:
-
- C:\SQL\SQLVBXDB C:\SQL\SQLVBXDB\SAMPLE42 C:\SQL\SQLVBXDB\SAMPLE10
-
- SQLVBXDB.VBX X
- SQLNDEF.BAS X
- SQLVBXDB.LIC X
- README.TXT X
- INSTALL.LOG X
- SQLVBXDB.HLP X
- SQLVBXDB.DHN X
- VBRUN300.DLL X
- SAMPAPP.HLP X
- LOGON.FRM X X
- MAINFORM.FRM X X
- GBASS.BAS X X
- GLOBAL.BAS X X
- SAMPLE42.MAK X
- SAMPLE10.MAK X
- SHOWMOD.EXE x
- D2HNAV.EXE windows directory
- D2HLINK.DLL windows/system directory
- D2HNAV.HLP windows directory
- MSOUTLIN.VBX windows/system directory
-
- The file SQLVBXDB.LIC is the licence file. This file must reside in
- the same directory as the file SQLVBXDB.VBX. This file is required if the
- SQL-Sombrero/VBX for DB-Library is to be used in developing an application.
- The SQLVBXDB.LIC file is not required for an application that is distributed
- as an EXE file. See the inside cover of the manual for further details on the
- .LIC file.
-
- The file SHOWMOD.EXE is provided as an extra. This program will show
- the modules which are currently loaded in the system. This file if chosen
- from the list of components is loaded into the WINDOWS directory. Use of the
- program is very simple. There is a list of currently loaded modules.
- Selecting a new entry in the list causes the information about that module to
- displayed to the right. This program is most useful to ensure that modules
- loaded are the correct module. This information can be determined from the
- directory from which the module is loaded and in some cases from the
- description of the module. Some manufactures of software do not use the
- version information for their modules. In this case the string "No data
- available" is displayed.
-
-
- ****** NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE ********
-
- If a SQL-Sombrero/VBX call does not seem to work as described in
- the manual please check the online help file. This file will always be
- the most current information about SQL-Sombrero/VBX.
-
- ****** NOTE NOTE NOTE NOTE NOTE NOTE NOTE NOTE ********
-
-
- *************************************************************************
-
- Here is the list of enhancements and changes to SQL-Sombrero/VBX since
- Version 1.0.0
-
- -------------
- March 16/1995 - (Version 1.0.4)
-
- This version contains the following fixes:
-
- The routines to handle image and text data have been updated. The SqlWriteText
- function has been fixed. In previous versions this function would report as
- not being found.
-
- In certain circumstances if multiple applications using SQL-Sombrero/VBX were
- loaded at the same time, a GPF would occur during the callback for error and
- server messages. This has been fixed in version 1.0.4.
-
- A new online help file is provided with fixes to the manual. The information
- in the online help is the most recent information about SQL-Sombrero/VBX.
-
-
- -----------
- Jan 27/1995 - (Version 1.0.3)
-
- This version contains the following fix:
-
- The routines SqlDateCrack, SqlRpcParam and SqlRPwSet could cause a GPF
- if an empty string "" was passed as a parameter.
-
- If any empty string is passed to SqlDateCrack the routine will proceed
- as if the string "Jan 01 1900" was sent. This is standard DB-Libray
- functionallity.
-
- If an empty string is passed to SqlRPwSet then the remote password will be
- set to the empty string.
-
- If an empty string is passed to SqlRpcParam the input parameter will be
- considered as a NULL parameter.
-
-
- -----------
- Jan 17/1995 - (Version 1.0.2)
-
- Fixed function SqlRpcParam. This function would only work correctly for
- datatype SQLCHAR. It now correctly converts the string supplied to the
- correct datatype. The documentation in the manual states that the second
- parameter for this function is the stored procedure name. This parameter
- is the parameter name for the function. This parameter is optional and
- will be ignored by DB-Library if an incorrect name is supplied. This is
- a "by design" behavior according to SYBASE.
-
-
- -----------
- Dec 13/1994 - (Version 1.0.1)
-
- The added functions are and are not currently in the SQL-Sombrero/VBX
- documentation.
-
- *******
- SombreroVersion$()
-
- Returns the version of SQL-Sombrero into a string
-
- Syntax
-
- ver$=SombreroVersion()
-
- Remarks
-
- This function can be called at any time.
-
- *******
- SqlFreeLogin
-
- Frees the memory allocated by SqlLogin% for a login record.
-
- Syntax
-
- SqlFreeLogin(loginrec%)
-
- loginrec%
-
- A login record. The value of loginrec% is returned by
- SqlLogin%.
-
-
- Remarks
-
- You can call SqlFreeLogin immediately after you call SqlOpen
- or you can use the same login record for multiple calls to
- SqlOpen. Call SqlFreeLogin when you are completely finished
- with a login record.
-
-
- *******
- SqlTabSource
-
- Returns the name and number of the table from which a result column
- derives.
-
- Syntax
-
- SqlTabSource$(sqlconn%, column%, tabnum%)
- sqlconn%
-
- A SQLáServer connection. The value of sqlconn% is returned by
- SqlOpen%.
-
- column%
-
- The number of the result column. Column numbers start at 1.
-
- tabnum%
-
- An integer variable to receive the table number. Many Visual
- Basic for SQLáServer functions that operate in browse mode
- accept either a table name or a table number. If SqlTabSource$
- returns an empty string, tabnum% is set to --1.
-
- Returns
-
- A string containing the name of the table from which a result column
- derives. If an empty string is returned, it means one of the following:
-
-
- -The SQLáServer connection is inactive. This is an error that
- invokes an application's error handler.
- -The SELECT statement does not contain the FOR BROWSE clause.
- -The column number is not in range.
- -The column is the result of an expression, such as MAX(colname).
-
-
- *******
- SqlTabName
-
- Returns the name of a table based on its number.
-
- Syntax
-
- SqlTabName$(sqlconn%, tabnum%)
- sqlconn%
-
- A SQLáServer connection. The value of sqlconn% is returned by
- SqlOpen%.
-
- tabnum%
-
- The number of a table. Table numbers start with 1. Use
- SqlTabCount% to find out the total number of tables involved in
- a particular statement.
-
- Returns
-
- A string containing the name of a specified table. This string is empty
- if the table number is out of range or if the specified table is a
- SQLáServer work table. For a description of work tables, see
- SqlTabCount%.
-
-
- ----------------------------------------------------------------------------
- Your input is welcomed on any subject and appreciated!
- ----------------------------------------------------------------------------
-
- You can reach us by fax at 819 778-7943 and by voice at 819 778-5045.
- You can always download the latest version of SQL-Sombrero/VBX by calling
- our BBS at 819-778-8556. (24 Hour Service)
-
- You can use our special Compuserve account for SQL-Programmer at 71162,1050.
- You can access our FAX ON DEMAND system by calling in manual mode from your
- FAX machine at 819 778-5045 and selecting the option "1" when entering the
- phone system. Request document index 50 for the latest list of available
- documents.
- ----------------------------------------------------------------------------
-
- Happy SQL-Programming!
-
- Thank you!
-
- ----------------------------------------------------------------------------
-
- Copyright 1994-1995 Sylvain Faust Inc.
- SQL-Programmer, SQL-Sombrero and CompressIT are Trademarks of Sylvain Faust Inc.
- Sylvain Faust Inc. claims copyright in this program and documentation.
- Claim of copyright does not imply waiver of Sylvain Faust Inc. other rights.
-
-
-
-